Learn relational database design from the ground up in this comprehensive course. This 8-week curriculum covers SQL fundamentals, entity-relationship modeling, normalization (1NF through BCNF), data types and constraints, indexing strategies, and query optimization.
You can get the complete learning experience with weekly schedules, quizzes and hands-on assignments at All materials are freely available.
This course is based on the book Grokking Relational Database Design by Dr. Qiang Hao and Dr. Michael Tsikerdekis (Manning Publications, 2025): The book provides additional depth and context with extended examples and a cohesive narrative that follows a single complex design throughout.
⭐️ Contents ⭐️
0:00:00 Relational Databases for Beginners — Tables, Entities, Keys & SQL
0:16:32 SQL Filtering & Aggregation
0:33:23 SQL Table Commands
0:45:57 Foreign Keys in SQL
1:01:54 How SQL JOINs Work
1:17:03 How to learn SQL on your own
1:31:48 Database Design Goals
1:39:25 Database Design Lifecycle
1:51:17 From Real-World Ideas to Tables
2:01:24 Primary Key, Candidate Key, and Super Key
2:14:25 Don't Use the Wrong SQL String Type
2:24:08 The FLOAT Mistake That Crashed a Stock Exchange
2:33:31 SQL Date and Time Types Explained
2:38:48 Connecting Entities in an ER Diagram
2:47:36 One-to-One Relationships
3:03:19 One-to-Many Relationships
3:14:18 Many-to-Many Relationships
3:24:54 Strong vs Weak Entities
3:38:05 First Normal Form - Primary Keys and Atomic Values
3:50:21 Second Normal
|
You can turn design mocks into working c...
Download your free Python Cheat Sheet he...
Learn relational database design from th...
Remember your first hackathon? While it ...
Looking for ways to improve your develop...
Android Studio now connects directly to ...
Download your free Python Cheat Sheet he...
Pipeline parallelism speeds up training ...
🔥Data Analyst Masters Program (Discount ...
Ready to crush your Amazon SQL interview...
🔥Purdue - Applied Generative AI Speciali...
This #shorts video by #simplilearn on Gi...
🔥Purdue - Applied Generative AI Speciali...
It's easy to get sucked into working too...
Looking to learn SQL quickly in 2026? In...
Download your free Python Cheat Sheet he...